package com.zzh.partnersys.mapper;

import com.zzh.partnersys.entity.TagDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zzh.partnersys.entity.vo.TagVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zzh
 * @since 2024-07-13
 */
public interface TagMapper extends BaseMapper<TagDO> {
    @Select("select tc.id,tc.categoryName,t.tagName from tag t , tag_category tc where t.categoryId = tc.id order by tc.id asc;")
    List<TagVO> selectAllTagsAndCategory();

}
